﻿<AdoNetDataAccess connection="$ContactsDBConnection$">
	<Sql>
		INSERT INTO Addresses
		(id,typeId,street1,street2,street3,city,stateProvince,zipCode,contactId,countryCode, longitude, latitude)
		VALUES
		(@id,@typeId,@street1,@street2,@street3,@city,@stateProvince,@zipCode,@contactId,@countryCode, @longitude, @latitude)
	</Sql>
	<Sql type="SqlServer">
	</Sql>
	<Param name="id" type="UniqueIdentifier" />
	<Param name="type.id" dbName="typeId" type="UniqueIdentifier" />
	<Param name="street1" type="String" />
	<Param name="street2" type="String" />
	<Param name="street3" type="String" />
	<Param name="city" type="String" />
	<Param name="stateProvince" type="String" />
	<Param name="zipCode" type="String" />
	<Param name="country.regionCode" dbName="countryCode"  type="UnicodeVarChar" />
	<Param name="contactId" type="UniqueIdentifier" />
	<Param name="longitude" type="String" />
	<Param name="latitude" type="String" />
</AdoNetDataAccess>